Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 34417 |
| Missing cells | 87581 |
| Missing cells (%) | 11.6% |
| Duplicate rows | 564 |
| Duplicate rows (%) | 1.6% |
| Total size in memory | 27.6 MiB |
| Average record size in memory | 841.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 4 |
| Boolean | 6 |
| Text | 2 |
IsMemberFlag has constant value "False" | Constant |
| Dataset has 564 (1.6%) duplicate rows | Duplicates |
AcademicDegreeLevel is highly overall correlated with IsAlumnusFlag | High correlation |
CumulativeDonationAmount is highly overall correlated with DonorIndicatorFlag. | High correlation |
DonorIndicatorFlag. is highly overall correlated with CumulativeDonationAmount | High correlation |
IsAlumnusFlag is highly overall correlated with AcademicDegreeLevel | High correlation |
MaritalStatus is highly imbalanced (57.9%) | Imbalance |
IsParentFlag is highly imbalanced (60.4%) | Imbalance |
PreferredAddressType is highly imbalanced (81.2%) | Imbalance |
MaritalStatus has 24507 (71.2%) missing values | Missing |
GenderIdentity has 492 (1.4%) missing values | Missing |
WealthRating has 31716 (92.2%) missing values | Missing |
AcademicDegreeLevel has 26835 (78.0%) missing values | Missing |
PreferredAddressType has 4031 (11.7%) missing values | Missing |
CumulativeDonationAmount is highly skewed (γ1 = 94.32672791) | Skewed |
ConsecutiveDonorYears has 18180 (52.8%) zeros | Zeros |
LastFiscalYearDonation has 32231 (93.6%) zeros | Zeros |
Donation2FiscalYearsAgo has 32156 (93.4%) zeros | Zeros |
Donation3FiscalYearsAgo has 32060 (93.2%) zeros | Zeros |
Donation4FiscalYearsAgo has 32407 (94.2%) zeros | Zeros |
Donation5FiscalYearsAgo has 32551 (94.6%) zeros | Zeros |
CurrentFiscalYearDonation has 32663 (94.9%) zeros | Zeros |
CumulativeDonationAmount has 13043 (37.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-04 19:09:06.507894 |
|---|---|
| Analysis finished | 2025-04-04 19:11:09.936015 |
| Duration | 2 minutes and 3.43 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
DonorAge
Real number (ℝ)
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.367638 |
| Minimum | 1 |
|---|---|
| Maximum | 110 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 42 |
| median | 42 |
| Q3 | 42 |
| 95-th percentile | 69 |
| Maximum | 110 |
| Range | 109 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.408334 |
|---|---|
| Coefficient of variation (CV) | 0.26306099 |
| Kurtosis | 4.296413 |
| Mean | 43.367638 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4383434 |
| Sum | 1492584 |
| Variance | 130.15008 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 42 | 21416 | |
| 32 | 381 | 1.1% |
| 30 | 366 | 1.1% |
| 31 | 351 | 1.0% |
| 27 | 336 | 1.0% |
| 33 | 331 | 1.0% |
| 35 | 325 | 0.9% |
| 29 | 322 | 0.9% |
| 34 | 317 | 0.9% |
| 37 | 308 | 0.9% |
| Other values (92) | 9964 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 3 | 12 | |
| 4 | 9 | |
| 5 | 14 | |
| 6 | 6 | |
| 7 | 13 | |
| 8 | 5 | < 0.1% |
| 9 | 5 | < 0.1% |
| 10 | 6 | |
| 11 | 10 |
| Value | Count | Frequency (%) |
| 110 | 2 | < 0.1% |
| 103 | 1 | < 0.1% |
| 101 | 1 | < 0.1% |
| 100 | 2 | < 0.1% |
| 99 | 2 | < 0.1% |
| 98 | 5 | < 0.1% |
| 97 | 5 | < 0.1% |
| 96 | 11 | |
| 95 | 8 | < 0.1% |
| 94 | 26 |
MaritalStatus
Categorical
Imbalance Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 24507 |
| Missing (%) | 71.2% |
| Memory size | 3.4 MiB |
| Married | |
|---|---|
| Single | |
| Widowed | 157 |
| Divorced | 84 |
| Separated | 9 |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 6.6959637 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Married |
|---|---|
| 2nd row | Married |
| 3rd row | Single |
| 4th row | Married |
| 5th row | Married |
Common Values
| Value | Count | Frequency (%) |
| Married | 6524 | 19.0% |
| Single | 3133 | 9.1% |
| Widowed | 157 | 0.5% |
| Divorced | 84 | 0.2% |
| Separated | 9 | < 0.1% |
| Never Married | 3 | < 0.1% |
| (Missing) | 24507 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| married | 6527 | |
| single | 3133 | |
| widowed | 157 | 1.6% |
| divorced | 84 | 0.8% |
| separated | 9 | 0.1% |
| never | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 13150 | |
| e | 9925 | |
| i | 9901 | |
| d | 6934 | |
| a | 6545 | |
| M | 6527 | |
| S | 3142 | 4.7% |
| n | 3133 | 4.7% |
| g | 3133 | 4.7% |
| l | 3133 | 4.7% |
| Other values (10) | 834 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 66357 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 13150 | |
| e | 9925 | |
| i | 9901 | |
| d | 6934 | |
| a | 6545 | |
| M | 6527 | |
| S | 3142 | 4.7% |
| n | 3133 | 4.7% |
| g | 3133 | 4.7% |
| l | 3133 | 4.7% |
| Other values (10) | 834 | 1.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 66357 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 13150 | |
| e | 9925 | |
| i | 9901 | |
| d | 6934 | |
| a | 6545 | |
| M | 6527 | |
| S | 3142 | 4.7% |
| n | 3133 | 4.7% |
| g | 3133 | 4.7% |
| l | 3133 | 4.7% |
| Other values (10) | 834 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 66357 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 13150 | |
| e | 9925 | |
| i | 9901 | |
| d | 6934 | |
| a | 6545 | |
| M | 6527 | |
| S | 3142 | 4.7% |
| n | 3133 | 4.7% |
| g | 3133 | 4.7% |
| l | 3133 | 4.7% |
| Other values (10) | 834 | 1.3% |
GenderIdentity
Categorical
Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 492 |
| Missing (%) | 1.4% |
| Memory size | 3.3 MiB |
| Female | |
|---|---|
| Male | |
| Uknown | 1088 |
| Unknown | 12 |
| U | 1 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.045689 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Female |
| 3rd row | Female |
| 4th row | Female |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Female | 16633 | |
| Male | 16191 | |
| Uknown | 1088 | 3.2% |
| Unknown | 12 | < 0.1% |
| U | 1 | < 0.1% |
| (Missing) | 492 | 1.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 16633 | |
| male | 16191 | |
| uknown | 1088 | 3.2% |
| unknown | 12 | < 0.1% |
| u | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 49457 | |
| l | 32824 | |
| a | 32824 | |
| m | 16633 | 9.7% |
| F | 16633 | 9.7% |
| M | 16191 | 9.5% |
| n | 2212 | 1.3% |
| U | 1101 | 0.6% |
| k | 1100 | 0.6% |
| o | 1100 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171175 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 49457 | |
| l | 32824 | |
| a | 32824 | |
| m | 16633 | 9.7% |
| F | 16633 | 9.7% |
| M | 16191 | 9.5% |
| n | 2212 | 1.3% |
| U | 1101 | 0.6% |
| k | 1100 | 0.6% |
| o | 1100 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171175 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 49457 | |
| l | 32824 | |
| a | 32824 | |
| m | 16633 | 9.7% |
| F | 16633 | 9.7% |
| M | 16191 | 9.5% |
| n | 2212 | 1.3% |
| U | 1101 | 0.6% |
| k | 1100 | 0.6% |
| o | 1100 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171175 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 49457 | |
| l | 32824 | |
| a | 32824 | |
| m | 16633 | 9.7% |
| F | 16633 | 9.7% |
| M | 16191 | 9.5% |
| n | 2212 | 1.3% |
| U | 1101 | 0.6% |
| k | 1100 | 0.6% |
| o | 1100 | 0.6% |
IsMemberFlag
Boolean
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 34417 |
IsAlumnusFlag
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 26021 | |
| True | 8396 | 24.4% |
IsParentFlag
Boolean
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| False | |
|---|---|
| True | 2691 |
| Value | Count | Frequency (%) |
| False | 31726 | |
| True | 2691 | 7.8% |
HasInvolvementFlag
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 26468 | |
| True | 7949 | 23.1% |
WealthRating
Real number (ℝ)
Missing
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 31716 |
| Missing (%) | 92.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9307664 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.51536 |
|---|---|
| Coefficient of variation (CV) | 0.51705248 |
| Kurtosis | -0.19021605 |
| Mean | 2.9307664 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.55064514 |
| Sum | 7916 |
| Variance | 2.296316 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 3 | 643 | 1.9% |
| 1 | 579 | 1.7% |
| 2 | 563 | 1.6% |
| 4 | 509 | 1.5% |
| 5 | 263 | 0.8% |
| 6 | 81 | 0.2% |
| 7 | 59 | 0.2% |
| 8 | 4 | < 0.1% |
| (Missing) | 31716 |
| Value | Count | Frequency (%) |
| 1 | 579 | |
| 2 | 563 | |
| 3 | 643 | |
| 4 | 509 | |
| 5 | 263 | |
| 6 | 81 | 0.2% |
| 7 | 59 | 0.2% |
| 8 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 8 | 4 | < 0.1% |
| 7 | 59 | 0.2% |
| 6 | 81 | 0.2% |
| 5 | 263 | |
| 4 | 509 | |
| 3 | 643 | |
| 2 | 563 | |
| 1 | 579 |
AcademicDegreeLevel
Categorical
High correlation Missing
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 26835 |
| Missing (%) | 78.0% |
| Memory size | 3.3 MiB |
| UB | |
|---|---|
| GM | |
| GP | |
| GD | 173 |
| GC | 74 |
| Other values (2) | 28 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UB |
|---|---|
| 2nd row | GP |
| 3rd row | GP |
| 4th row | GM |
| 5th row | GM |
Common Values
| Value | Count | Frequency (%) |
| UB | 3632 | 10.6% |
| GM | 3106 | 9.0% |
| GP | 569 | 1.7% |
| GD | 173 | 0.5% |
| GC | 74 | 0.2% |
| UC | 19 | 0.1% |
| UG | 9 | < 0.1% |
| (Missing) | 26835 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ub | 3632 | |
| gm | 3106 | |
| gp | 569 | 7.5% |
| gd | 173 | 2.3% |
| gc | 74 | 1.0% |
| uc | 19 | 0.3% |
| ug | 9 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 3931 | |
| U | 3660 | |
| B | 3632 | |
| M | 3106 | |
| P | 569 | 3.8% |
| D | 173 | 1.1% |
| C | 93 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15164 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 3931 | |
| U | 3660 | |
| B | 3632 | |
| M | 3106 | |
| P | 569 | 3.8% |
| D | 173 | 1.1% |
| C | 93 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15164 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 3931 | |
| U | 3660 | |
| B | 3632 | |
| M | 3106 | |
| P | 569 | 3.8% |
| D | 173 | 1.1% |
| C | 93 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15164 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 3931 | |
| U | 3660 | |
| B | 3632 | |
| M | 3106 | |
| P | 569 | 3.8% |
| D | 173 | 1.1% |
| C | 93 | 0.6% |
PreferredAddressType
Categorical
Imbalance Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4031 |
| Missing (%) | 11.7% |
| Memory size | 3.3 MiB |
| HOME | |
|---|---|
| BUSN | 973 |
| CAMP | 645 |
| OTR | 71 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9976634 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HOME |
|---|---|
| 2nd row | HOME |
| 3rd row | HOME |
| 4th row | HOME |
| 5th row | HOME |
Common Values
| Value | Count | Frequency (%) |
| HOME | 28697 | |
| BUSN | 973 | 2.8% |
| CAMP | 645 | 1.9% |
| OTR | 71 | 0.2% |
| (Missing) | 4031 | 11.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| home | 28697 | |
| busn | 973 | 3.2% |
| camp | 645 | 2.1% |
| otr | 71 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 29342 | |
| O | 28768 | |
| H | 28697 | |
| E | 28697 | |
| B | 973 | 0.8% |
| U | 973 | 0.8% |
| S | 973 | 0.8% |
| N | 973 | 0.8% |
| C | 645 | 0.5% |
| A | 645 | 0.5% |
| Other values (3) | 787 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 121473 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 29342 | |
| O | 28768 | |
| H | 28697 | |
| E | 28697 | |
| B | 973 | 0.8% |
| U | 973 | 0.8% |
| S | 973 | 0.8% |
| N | 973 | 0.8% |
| C | 645 | 0.5% |
| A | 645 | 0.5% |
| Other values (3) | 787 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 121473 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 29342 | |
| O | 28768 | |
| H | 28697 | |
| E | 28697 | |
| B | 973 | 0.8% |
| U | 973 | 0.8% |
| S | 973 | 0.8% |
| N | 973 | 0.8% |
| C | 645 | 0.5% |
| A | 645 | 0.5% |
| Other values (3) | 787 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 121473 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 29342 | |
| O | 28768 | |
| H | 28697 | |
| E | 28697 | |
| B | 973 | 0.8% |
| U | 973 | 0.8% |
| S | 973 | 0.8% |
| N | 973 | 0.8% |
| C | 645 | 0.5% |
| A | 645 | 0.5% |
| Other values (3) | 787 | 0.6% |
| Value | Count | Frequency (%) |
| False | 23160 | |
| True | 11257 |
ConsecutiveDonorYears
Real number (ℝ)
Zeros
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1383619 |
| Minimum | 0 |
|---|---|
| Maximum | 36 |
| Zeros | 18180 |
| Zeros (%) | 52.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.4247456 |
|---|---|
| Coefficient of variation (CV) | 2.1300306 |
| Kurtosis | 37.9043 |
| Mean | 1.1383619 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.1020811 |
| Sum | 39179 |
| Variance | 5.879391 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 0 | 18180 | |
| 1 | 9675 | |
| 2 | 2505 | 7.3% |
| 3 | 1418 | 4.1% |
| 4 | 689 | 2.0% |
| 5 | 468 | 1.4% |
| 6 | 344 | 1.0% |
| 7 | 233 | 0.7% |
| 8 | 155 | 0.5% |
| 10 | 132 | 0.4% |
| Other values (23) | 618 | 1.8% |
| Value | Count | Frequency (%) |
| 0 | 18180 | |
| 1 | 9675 | |
| 2 | 2505 | 7.3% |
| 3 | 1418 | 4.1% |
| 4 | 689 | 2.0% |
| 5 | 468 | 1.4% |
| 6 | 344 | 1.0% |
| 7 | 233 | 0.7% |
| 8 | 155 | 0.5% |
| 9 | 123 | 0.4% |
| Value | Count | Frequency (%) |
| 36 | 1 | < 0.1% |
| 35 | 3 | < 0.1% |
| 34 | 5 | |
| 30 | 8 | |
| 28 | 8 | |
| 27 | 2 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 6 | |
| 24 | 7 | |
| 23 | 4 |
LastFiscalYearDonation
Real number (ℝ)
Zeros
| Distinct | 121 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.0662754 |
| Minimum | 0 |
|---|---|
| Maximum | 850 |
| Zeros | 32231 |
| Zeros (%) | 93.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 850 |
| Range | 850 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 39.745752 |
|---|---|
| Coefficient of variation (CV) | 6.5519201 |
| Kurtosis | 135.73426 |
| Mean | 6.0662754 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.359262 |
| Sum | 208783 |
| Variance | 1579.7248 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32231 | |
| 1 | 494 | 1.4% |
| 100 | 192 | 0.6% |
| 50 | 185 | 0.5% |
| 25 | 149 | 0.4% |
| 120 | 111 | 0.3% |
| 200 | 75 | 0.2% |
| 40 | 66 | 0.2% |
| 20 | 66 | 0.2% |
| 500 | 53 | 0.2% |
| Other values (111) | 795 | 2.3% |
| Value | Count | Frequency (%) |
| 0 | 32231 | |
| 1 | 494 | 1.4% |
| 2 | 27 | 0.1% |
| 3 | 4 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 30 | 0.1% |
| 6 | 7 | < 0.1% |
| 10 | 44 | 0.1% |
| 11 | 4 | < 0.1% |
| 12 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 850 | 2 | < 0.1% |
| 826 | 2 | < 0.1% |
| 750 | 7 | |
| 715 | 2 | < 0.1% |
| 700 | 4 | |
| 652 | 1 | < 0.1% |
| 600 | 5 | |
| 550 | 4 | |
| 510 | 4 | |
| 509 | 1 | < 0.1% |
Donation2FiscalYearsAgo
Real number (ℝ)
Zeros
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4540779 |
| Minimum | 0 |
|---|---|
| Maximum | 950 |
| Zeros | 32156 |
| Zeros (%) | 93.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5 |
| Maximum | 950 |
| Range | 950 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 41.763763 |
|---|---|
| Coefficient of variation (CV) | 6.4709109 |
| Kurtosis | 128.16301 |
| Mean | 6.4540779 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.084023 |
| Sum | 222130 |
| Variance | 1744.2119 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32156 | |
| 1 | 440 | 1.3% |
| 50 | 185 | 0.5% |
| 100 | 178 | 0.5% |
| 25 | 151 | 0.4% |
| 120 | 118 | 0.3% |
| 200 | 85 | 0.2% |
| 5 | 76 | 0.2% |
| 20 | 72 | 0.2% |
| 10 | 65 | 0.2% |
| Other values (118) | 891 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 32156 | |
| 1 | 440 | 1.3% |
| 2 | 28 | 0.1% |
| 3 | 4 | < 0.1% |
| 5 | 76 | 0.2% |
| 6 | 4 | < 0.1% |
| 8 | 2 | < 0.1% |
| 10 | 65 | 0.2% |
| 12 | 1 | < 0.1% |
| 14 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 950 | 1 | < 0.1% |
| 935 | 1 | < 0.1% |
| 900 | 1 | < 0.1% |
| 804 | 1 | < 0.1% |
| 800 | 4 | |
| 750 | 1 | < 0.1% |
| 700 | 2 | |
| 690 | 1 | < 0.1% |
| 670 | 1 | < 0.1% |
| 664 | 3 |
Donation3FiscalYearsAgo
Real number (ℝ)
Zeros
| Distinct | 133 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4317924 |
| Minimum | 0 |
|---|---|
| Maximum | 995 |
| Zeros | 32060 |
| Zeros (%) | 93.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 20 |
| Maximum | 995 |
| Range | 995 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 40.092869 |
|---|---|
| Coefficient of variation (CV) | 6.2335452 |
| Kurtosis | 131.04004 |
| Mean | 6.4317924 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.083688 |
| Sum | 221363 |
| Variance | 1607.4381 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32060 | |
| 1 | 371 | 1.1% |
| 100 | 224 | 0.7% |
| 50 | 183 | 0.5% |
| 25 | 166 | 0.5% |
| 20 | 91 | 0.3% |
| 200 | 88 | 0.3% |
| 40 | 87 | 0.3% |
| 5 | 86 | 0.2% |
| 120 | 80 | 0.2% |
| Other values (123) | 981 | 2.9% |
| Value | Count | Frequency (%) |
| 0 | 32060 | |
| 1 | 371 | 1.1% |
| 2 | 6 | < 0.1% |
| 3 | 2 | < 0.1% |
| 5 | 86 | 0.2% |
| 6 | 12 | < 0.1% |
| 7 | 3 | < 0.1% |
| 8 | 10 | < 0.1% |
| 10 | 58 | 0.2% |
| 11 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 995 | 1 | < 0.1% |
| 802 | 1 | < 0.1% |
| 800 | 4 | |
| 750 | 2 | < 0.1% |
| 720 | 2 | < 0.1% |
| 700 | 2 | < 0.1% |
| 675 | 5 | |
| 600 | 7 | |
| 590 | 3 | |
| 560 | 3 |
Donation4FiscalYearsAgo
Real number (ℝ)
Zeros
| Distinct | 130 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.2285498 |
| Minimum | 0 |
|---|---|
| Maximum | 925 |
| Zeros | 32407 |
| Zeros (%) | 94.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 15 |
| Maximum | 925 |
| Range | 925 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 40.052117 |
|---|---|
| Coefficient of variation (CV) | 6.430408 |
| Kurtosis | 143.05482 |
| Mean | 6.2285498 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.431776 |
| Sum | 214368 |
| Variance | 1604.1721 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32407 | |
| 100 | 215 | 0.6% |
| 50 | 194 | 0.6% |
| 25 | 172 | 0.5% |
| 1 | 130 | 0.4% |
| 40 | 97 | 0.3% |
| 5 | 86 | 0.2% |
| 20 | 86 | 0.2% |
| 200 | 81 | 0.2% |
| 150 | 58 | 0.2% |
| Other values (120) | 891 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 32407 | |
| 1 | 130 | 0.4% |
| 2 | 3 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 86 | 0.2% |
| 6 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
| 10 | 56 | 0.2% |
| 11 | 2 | < 0.1% |
| 15 | 43 | 0.1% |
| Value | Count | Frequency (%) |
| 925 | 2 | < 0.1% |
| 917 | 4 | |
| 880 | 1 | < 0.1% |
| 750 | 4 | |
| 700 | 3 | |
| 640 | 1 | < 0.1% |
| 613 | 1 | < 0.1% |
| 600 | 5 | |
| 550 | 2 | < 0.1% |
| 508 | 2 | < 0.1% |
Donation5FiscalYearsAgo
Real number (ℝ)
Zeros
| Distinct | 146 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.0019177 |
| Minimum | 0 |
|---|---|
| Maximum | 992 |
| Zeros | 32551 |
| Zeros (%) | 94.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5 |
| Maximum | 992 |
| Range | 992 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 40.237324 |
|---|---|
| Coefficient of variation (CV) | 6.704078 |
| Kurtosis | 157.99652 |
| Mean | 6.0019177 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.080816 |
| Sum | 206568 |
| Variance | 1619.0422 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32551 | |
| 100 | 237 | 0.7% |
| 25 | 184 | 0.5% |
| 50 | 133 | 0.4% |
| 1 | 127 | 0.4% |
| 40 | 83 | 0.2% |
| 200 | 79 | 0.2% |
| 20 | 66 | 0.2% |
| 10 | 61 | 0.2% |
| 144 | 57 | 0.2% |
| Other values (136) | 839 | 2.4% |
| Value | Count | Frequency (%) |
| 0 | 32551 | |
| 1 | 127 | 0.4% |
| 2 | 9 | < 0.1% |
| 3 | 6 | < 0.1% |
| 5 | 27 | 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 4 | < 0.1% |
| 10 | 61 | 0.2% |
| 11 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 992 | 2 | |
| 901 | 2 | |
| 825 | 1 | < 0.1% |
| 802 | 1 | < 0.1% |
| 800 | 2 | |
| 750 | 4 | |
| 700 | 2 | |
| 660 | 4 | |
| 652 | 3 | |
| 640 | 1 | < 0.1% |
CurrentFiscalYearDonation
Real number (ℝ)
Zeros
| Distinct | 113 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.6223669 |
| Minimum | 0 |
|---|---|
| Maximum | 988 |
| Zeros | 32663 |
| Zeros (%) | 94.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 988 |
| Range | 988 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 40.155082 |
|---|---|
| Coefficient of variation (CV) | 7.1420246 |
| Kurtosis | 164.23114 |
| Mean | 5.6223669 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.446759 |
| Sum | 193505 |
| Variance | 1612.4306 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 32663 | |
| 1 | 303 | 0.9% |
| 100 | 203 | 0.6% |
| 50 | 164 | 0.5% |
| 25 | 126 | 0.4% |
| 120 | 89 | 0.3% |
| 110 | 81 | 0.2% |
| 500 | 46 | 0.1% |
| 200 | 45 | 0.1% |
| 60 | 37 | 0.1% |
| Other values (103) | 660 | 1.9% |
| Value | Count | Frequency (%) |
| 0 | 32663 | |
| 1 | 303 | 0.9% |
| 2 | 6 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 28 | 0.1% |
| 10 | 33 | 0.1% |
| 12 | 1 | < 0.1% |
| 15 | 13 | < 0.1% |
| 18 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 988 | 2 | < 0.1% |
| 800 | 10 | |
| 750 | 3 | < 0.1% |
| 725 | 1 | < 0.1% |
| 700 | 4 | < 0.1% |
| 660 | 2 | < 0.1% |
| 630 | 2 | < 0.1% |
| 610 | 1 | < 0.1% |
| 600 | 6 | |
| 550 | 4 | < 0.1% |
CumulativeDonationAmount
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 1593 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23690.67 |
| Minimum | 0 |
|---|---|
| Maximum | 1.2221854 × 108 |
| Zeros | 13043 |
| Zeros (%) | 37.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 250 |
| Q3 | 1440 |
| 95-th percentile | 13090 |
| Maximum | 1.2221854 × 108 |
| Range | 1.2221854 × 108 |
| Interquartile range (IQR) | 1440 |
Descriptive statistics
| Standard deviation | 1139517.4 |
|---|---|
| Coefficient of variation (CV) | 48.099838 |
| Kurtosis | 9588.7414 |
| Mean | 23690.67 |
| Median Absolute Deviation (MAD) | 250 |
| Skewness | 94.326728 |
| Sum | 8.1536179 × 108 |
| Variance | 1.2984999 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 13043 | |
| 1000 | 1254 | 3.6% |
| 500 | 1226 | 3.6% |
| 250 | 1210 | 3.5% |
| 10 | 1096 | 3.2% |
| 1200 | 645 | 1.9% |
| 100 | 633 | 1.8% |
| 200 | 568 | 1.7% |
| 2000 | 487 | 1.4% |
| 400 | 483 | 1.4% |
| Other values (1583) | 13772 |
| Value | Count | Frequency (%) |
| 0 | 13043 | |
| 10 | 1096 | 3.2% |
| 20 | 135 | 0.4% |
| 30 | 97 | 0.3% |
| 40 | 63 | 0.2% |
| 50 | 463 | 1.3% |
| 60 | 47 | 0.1% |
| 70 | 32 | 0.1% |
| 80 | 26 | 0.1% |
| 90 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 122218540 | 2 | |
| 102005740 | 1 | |
| 34551880 | 1 | |
| 24404600 | 1 | |
| 23929200 | 1 | |
| 15942860 | 2 | |
| 15100000 | 1 | |
| 15000000 | 1 | |
| 14691600 | 1 | |
| 12600000 | 1 |
DonorIndicatorFlag.
Boolean
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 21374 | |
| False | 13043 |
STATE
Text
| Distinct | 61 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 2 |
| Mean length | 2.0703141 |
| Min length | 2 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | VA |
|---|---|
| 2nd row | TX |
| 3rd row | IN |
| 4th row | CA |
| 5th row | CA |
| Value | Count | Frequency (%) |
| ca | 7570 | |
| tx | 1731 | 5.0% |
| pa | 1426 | 4.1% |
| ny | 1412 | 4.1% |
| none | 1210 | 3.5% |
| il | 1031 | 3.0% |
| fl | 1002 | 2.9% |
| oh | 909 | 2.6% |
| mi | 783 | 2.3% |
| va | 778 | 2.3% |
| Other values (51) | 16565 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 14427 | |
| C | 9458 | |
| N | 6900 | 9.7% |
| M | 4220 | 5.9% |
| I | 4132 | 5.8% |
| T | 3191 | 4.5% |
| L | 2991 | 4.2% |
| O | 2858 | 4.0% |
| Y | 2141 | 3.0% |
| K | 1815 | 2.5% |
| Other values (17) | 19121 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 71254 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 14427 | |
| C | 9458 | |
| N | 6900 | 9.7% |
| M | 4220 | 5.9% |
| I | 4132 | 5.8% |
| T | 3191 | 4.5% |
| L | 2991 | 4.2% |
| O | 2858 | 4.0% |
| Y | 2141 | 3.0% |
| K | 1815 | 2.5% |
| Other values (17) | 19121 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 71254 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 14427 | |
| C | 9458 | |
| N | 6900 | 9.7% |
| M | 4220 | 5.9% |
| I | 4132 | 5.8% |
| T | 3191 | 4.5% |
| L | 2991 | 4.2% |
| O | 2858 | 4.0% |
| Y | 2141 | 3.0% |
| K | 1815 | 2.5% |
| Other values (17) | 19121 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 71254 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 14427 | |
| C | 9458 | |
| N | 6900 | 9.7% |
| M | 4220 | 5.9% |
| I | 4132 | 5.8% |
| T | 3191 | 4.5% |
| L | 2991 | 4.2% |
| O | 2858 | 4.0% |
| Y | 2141 | 3.0% |
| K | 1815 | 2.5% |
| Other values (17) | 19121 |
CITY
Text
| Distinct | 10830 |
|---|---|
| Distinct (%) | 31.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
Length
| Max length | 26 |
|---|---|
| Median length | 24 |
| Mean length | 7.9456373 |
| Min length | 3 |
Unique
| Unique | 5941 ? |
|---|---|
| Unique (%) | 17.3% |
Sample
| 1st row | Williamsburg |
|---|---|
| 2nd row | Port Arthur |
| 3rd row | Marysville |
| 4th row | Moreno Valley |
| 5th row | San Jose |
| Value | Count | Frequency (%) |
| malibu | 5849 | 14.1% |
| none | 1210 | 2.9% |
| city | 535 | 1.3% |
| new | 368 | 0.9% |
| san | 291 | 0.7% |
| saint | 274 | 0.7% |
| lake | 273 | 0.7% |
| fort | 228 | 0.6% |
| apo | 222 | 0.5% |
| springs | 222 | 0.5% |
| Other values (9123) | 31970 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 25853 | 9.5% |
| e | 22705 | 8.3% |
| l | 22120 | 8.1% |
| i | 20030 | 7.3% |
| o | 19040 | 7.0% |
| n | 18604 | 6.8% |
| r | 14939 | 5.5% |
| t | 12267 | 4.5% |
| u | 11147 | 4.1% |
| s | 9722 | 3.6% |
| Other values (44) | 97038 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 273465 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 25853 | 9.5% |
| e | 22705 | 8.3% |
| l | 22120 | 8.1% |
| i | 20030 | 7.3% |
| o | 19040 | 7.0% |
| n | 18604 | 6.8% |
| r | 14939 | 5.5% |
| t | 12267 | 4.5% |
| u | 11147 | 4.1% |
| s | 9722 | 3.6% |
| Other values (44) | 97038 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 273465 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 25853 | 9.5% |
| e | 22705 | 8.3% |
| l | 22120 | 8.1% |
| i | 20030 | 7.3% |
| o | 19040 | 7.0% |
| n | 18604 | 6.8% |
| r | 14939 | 5.5% |
| t | 12267 | 4.5% |
| u | 11147 | 4.1% |
| s | 9722 | 3.6% |
| Other values (44) | 97038 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 273465 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 25853 | 9.5% |
| e | 22705 | 8.3% |
| l | 22120 | 8.1% |
| i | 20030 | 7.3% |
| o | 19040 | 7.0% |
| n | 18604 | 6.8% |
| r | 14939 | 5.5% |
| t | 12267 | 4.5% |
| u | 11147 | 4.1% |
| s | 9722 | 3.6% |
| Other values (44) | 97038 |
Interactions
Correlations
| AcademicDegreeLevel | ConsecutiveDonorYears | CumulativeDonationAmount | CurrentFiscalYearDonation | Donation2FiscalYearsAgo | Donation3FiscalYearsAgo | Donation4FiscalYearsAgo | Donation5FiscalYearsAgo | DonorAge | DonorIndicatorFlag. | GenderIdentity | HasEmailFlag | HasInvolvementFlag | IsAlumnusFlag | IsParentFlag | LastFiscalYearDonation | MaritalStatus | PreferredAddressType | WealthRating | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AcademicDegreeLevel | 1.000 | 0.049 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.088 | 0.021 | 0.038 | 0.049 | 0.152 | 1.000 | 0.017 | 0.000 | 0.000 | 0.044 | 0.140 |
| ConsecutiveDonorYears | 0.049 | 1.000 | 0.151 | -0.005 | -0.005 | 0.169 | 0.010 | 0.256 | 0.034 | 0.142 | 0.025 | 0.037 | 0.164 | 0.069 | 0.037 | 0.003 | 0.068 | 0.018 | 0.043 |
| CumulativeDonationAmount | 0.000 | 0.151 | 1.000 | 0.173 | 0.202 | 0.221 | 0.198 | 0.209 | 0.020 | 0.977 | 0.000 | 0.041 | 0.111 | 0.055 | 0.000 | 0.183 | 0.149 | 0.000 | 0.003 |
| CurrentFiscalYearDonation | 0.000 | -0.005 | 0.173 | 1.000 | -0.007 | -0.009 | 0.000 | -0.006 | 0.004 | 0.119 | 0.021 | 0.012 | 0.004 | 0.009 | 0.016 | 0.003 | 0.000 | 0.000 | -0.007 |
| Donation2FiscalYearsAgo | 0.000 | -0.005 | 0.202 | -0.007 | 1.000 | 0.249 | 0.041 | -0.005 | -0.003 | 0.123 | 0.000 | 0.000 | 0.005 | 0.000 | 0.003 | 0.001 | 0.000 | 0.000 | -0.002 |
| Donation3FiscalYearsAgo | 0.000 | 0.169 | 0.221 | -0.009 | 0.249 | 1.000 | 0.075 | 0.019 | 0.004 | 0.125 | 0.000 | 0.002 | 0.000 | 0.000 | 0.028 | 0.014 | 0.000 | 0.009 | 0.027 |
| Donation4FiscalYearsAgo | 0.000 | 0.010 | 0.198 | 0.000 | 0.041 | 0.075 | 1.000 | 0.007 | 0.010 | 0.122 | 0.000 | 0.000 | 0.007 | 0.000 | 0.012 | 0.007 | 0.000 | 0.032 | -0.036 |
| Donation5FiscalYearsAgo | 0.004 | 0.256 | 0.209 | -0.006 | -0.005 | 0.019 | 0.007 | 1.000 | 0.027 | 0.121 | 0.000 | 0.011 | 0.068 | 0.026 | 0.020 | -0.005 | 0.016 | 0.016 | 0.011 |
| DonorAge | 0.088 | 0.034 | 0.020 | 0.004 | -0.003 | 0.004 | 0.010 | 0.027 | 1.000 | 0.025 | 0.066 | 0.268 | 0.142 | 0.283 | 0.113 | -0.005 | 0.050 | 0.141 | -0.004 |
| DonorIndicatorFlag. | 0.021 | 0.142 | 0.977 | 0.119 | 0.123 | 0.125 | 0.122 | 0.121 | 0.025 | 1.000 | 0.022 | 0.001 | 0.037 | 0.015 | 0.008 | 0.126 | 0.038 | 0.009 | 0.000 |
| GenderIdentity | 0.038 | 0.025 | 0.000 | 0.021 | 0.000 | 0.000 | 0.000 | 0.000 | 0.066 | 0.022 | 1.000 | 0.059 | 0.156 | 0.082 | 0.046 | 0.000 | 0.207 | 0.022 | 0.000 |
| HasEmailFlag | 0.049 | 0.037 | 0.041 | 0.012 | 0.000 | 0.002 | 0.000 | 0.011 | 0.268 | 0.001 | 0.059 | 1.000 | 0.307 | 0.364 | 0.164 | 0.010 | 0.213 | 0.188 | 0.064 |
| HasInvolvementFlag | 0.152 | 0.164 | 0.111 | 0.004 | 0.005 | 0.000 | 0.007 | 0.068 | 0.142 | 0.037 | 0.156 | 0.307 | 1.000 | 0.437 | 0.031 | 0.000 | 0.086 | 0.059 | 0.027 |
| IsAlumnusFlag | 1.000 | 0.069 | 0.055 | 0.009 | 0.000 | 0.000 | 0.000 | 0.026 | 0.283 | 0.015 | 0.082 | 0.364 | 0.437 | 1.000 | 0.087 | 0.004 | 0.137 | 0.047 | 0.000 |
| IsParentFlag | 0.017 | 0.037 | 0.000 | 0.016 | 0.003 | 0.028 | 0.012 | 0.020 | 0.113 | 0.008 | 0.046 | 0.164 | 0.031 | 0.087 | 1.000 | 0.000 | 0.381 | 0.047 | 0.020 |
| LastFiscalYearDonation | 0.000 | 0.003 | 0.183 | 0.003 | 0.001 | 0.014 | 0.007 | -0.005 | -0.005 | 0.126 | 0.000 | 0.010 | 0.000 | 0.004 | 0.000 | 1.000 | 0.000 | 0.001 | 0.021 |
| MaritalStatus | 0.000 | 0.068 | 0.149 | 0.000 | 0.000 | 0.000 | 0.000 | 0.016 | 0.050 | 0.038 | 0.207 | 0.213 | 0.086 | 0.137 | 0.381 | 0.000 | 1.000 | 0.049 | 0.000 |
| PreferredAddressType | 0.044 | 0.018 | 0.000 | 0.000 | 0.000 | 0.009 | 0.032 | 0.016 | 0.141 | 0.009 | 0.022 | 0.188 | 0.059 | 0.047 | 0.047 | 0.001 | 0.049 | 1.000 | 0.037 |
| WealthRating | 0.140 | 0.043 | 0.003 | -0.007 | -0.002 | 0.027 | -0.036 | 0.011 | -0.004 | 0.000 | 0.000 | 0.064 | 0.027 | 0.000 | 0.020 | 0.021 | 0.000 | 0.037 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| DonorAge | MaritalStatus | GenderIdentity | IsMemberFlag | IsAlumnusFlag | IsParentFlag | HasInvolvementFlag | WealthRating | AcademicDegreeLevel | PreferredAddressType | HasEmailFlag | ConsecutiveDonorYears | LastFiscalYearDonation | Donation2FiscalYearsAgo | Donation3FiscalYearsAgo | Donation4FiscalYearsAgo | Donation5FiscalYearsAgo | CurrentFiscalYearDonation | CumulativeDonationAmount | DonorIndicatorFlag. | STATE | CITY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 42 | Married | Female | N | N | N | N | NaN | NaN | HOME | N | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | Y | VA | Williamsburg |
| 1 | 33 | NaN | Female | N | Y | N | Y | NaN | UB | NaN | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21000 | Y | TX | Port Arthur |
| 3 | 31 | NaN | Female | N | Y | N | Y | NaN | NaN | HOME | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | IN | Marysville |
| 4 | 68 | NaN | Female | N | N | N | N | NaN | NaN | HOME | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5050 | Y | CA | Moreno Valley |
| 5 | 57 | NaN | Male | N | N | N | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | San Jose |
| 6 | 42 | NaN | Male | N | N | N | N | NaN | NaN | HOME | Y | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu |
| 7 | 42 | Married | Female | N | N | N | N | NaN | NaN | HOME | N | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1700 | Y | KS | Colby |
| 8 | 42 | Single | Uknown | N | N | N | Y | NaN | NaN | HOME | N | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 50 | Y | CA | Rackerby |
| 9 | 42 | Married | Female | N | N | Y | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | Y | MI | Shingleton |
| 10 | 40 | NaN | Male | N | N | N | N | NaN | NaN | HOME | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | WA | Bellevue |
| DonorAge | MaritalStatus | GenderIdentity | IsMemberFlag | IsAlumnusFlag | IsParentFlag | HasInvolvementFlag | WealthRating | AcademicDegreeLevel | PreferredAddressType | HasEmailFlag | ConsecutiveDonorYears | LastFiscalYearDonation | Donation2FiscalYearsAgo | Donation3FiscalYearsAgo | Donation4FiscalYearsAgo | Donation5FiscalYearsAgo | CurrentFiscalYearDonation | CumulativeDonationAmount | DonorIndicatorFlag. | STATE | CITY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34498 | 42 | NaN | Male | N | N | N | N | NaN | NaN | HOME | N | 1 | 20 | 0 | 0 | 0 | 0 | 0 | 200 | Y | CA | Malibu |
| 34499 | 57 | NaN | Female | N | N | N | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | Y | CA | Malibu |
| 34500 | 42 | NaN | Female | N | N | N | Y | NaN | NaN | HOME | Y | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 2900 | Y | DC | Washington |
| 34501 | 42 | NaN | Female | N | N | N | Y | NaN | NaN | BUSN | N | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2650 | Y | KY | Smilax |
| 34502 | 42 | Married | Male | N | N | Y | N | 2.0 | NaN | HOME | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | IA | Ridgeway |
| 34503 | 42 | NaN | Female | N | N | N | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | NJ | Lafayette |
| 34504 | 24 | NaN | Male | N | N | N | N | 5.0 | NaN | CAMP | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | Y | NC | Charlotte |
| 34505 | 27 | NaN | Female | N | Y | N | Y | NaN | UB | HOME | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | KY | Liberty |
| 34506 | 46 | Married | Female | N | N | N | Y | NaN | NaN | HOME | Y | 1 | 0 | 0 | 0 | 120 | 0 | 0 | 1200 | Y | FL | Goldenrod |
| 34507 | 58 | Married | Female | N | Y | N | Y | NaN | UB | HOME | Y | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | NY | New York |
Duplicate rows
Most frequently occurring
| DonorAge | MaritalStatus | GenderIdentity | IsMemberFlag | IsAlumnusFlag | IsParentFlag | HasInvolvementFlag | WealthRating | AcademicDegreeLevel | PreferredAddressType | HasEmailFlag | ConsecutiveDonorYears | LastFiscalYearDonation | Donation2FiscalYearsAgo | Donation3FiscalYearsAgo | Donation4FiscalYearsAgo | Donation5FiscalYearsAgo | CurrentFiscalYearDonation | CumulativeDonationAmount | DonorIndicatorFlag. | STATE | CITY | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370 | 42 | NaN | Male | N | N | N | N | NaN | NaN | HOME | N | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 114 |
| 261 | 42 | NaN | Female | N | N | N | N | NaN | NaN | HOME | N | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 90 |
| 144 | 42 | Married | Male | N | N | N | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 33 |
| 155 | 42 | Married | Male | N | N | N | N | NaN | NaN | HOME | N | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 30 |
| 187 | 42 | Married | Male | N | N | Y | N | NaN | NaN | HOME | Y | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 30 |
| 220 | 42 | Single | Male | N | N | N | N | NaN | NaN | NaN | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 29 |
| 102 | 42 | Married | Female | N | N | N | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 28 |
| 233 | 42 | Single | Uknown | N | N | N | Y | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 28 |
| 412 | 42 | NaN | Male | N | N | N | N | NaN | NaN | HOME | N | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 24 |
| 251 | 42 | NaN | Female | N | N | N | N | NaN | NaN | HOME | N | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00 | N | CA | Malibu | 23 |